Helpful Information
Home
Categories
Contact us
Category: Php/mysql
Php/mysql --> php/oracle 9i
I just started using oracle and I'm having difficulties switching functions in php from mysql to oracle. Can someone translate the following code into something that will work for oracle.
$sql = "Select * from table";
$resultID = mysql_query($sql);
while( list($row1data,$row2data) = mysql_fetch_row($resultID) )
{
echo $row1data,$row2data; //or whatever
}
Thanks in advance!
would something like this work...
<?php
ociplogon($user,$pass,$host);
$sql = "Select * from table";
ora_parse($cursor,$sql);
ora_exec($cursor);
while( list($row1data, $row2data) = ora_fetch($cursor))
{
echo "row1: " . $row1data . " row2: " . $row2data . "<br>\n";
}
?>
Thanks in advance!
privacy (GDPR)